Error Executing: DEFAULT_ROW

DEFAULT_ROW: Unable to find row in table 'tccp.staff' matching condition: 'id = 19'

DEFAULT_ROW command reference

Invoked From: template id 1208 using template path /proto/Modules/Board_of_Directors/BOD_Preview

Error Occurred In Command Block At Lines 3-70:

SET bodytext {
[
	INCLUDE LIBNAME \"PserverLib\"
	set theParms [split $ID |]
	set cmd [lindex $theParms 0]
	NULL
	
	if {[SHOW staffid] == \"\"} {
		set staffid [lindex $theParms 1]
		NULL
	}

if {$cmd == \"one\" || $cmd == \"\"} {
		DEFAULT_ROW $schema.staff \"*\" \"id = [SHOW staffid]\"
		set name [FIELD name]
		set title [FIELD title]
		set email [FIELD email]
		set bio [FIELD bio]
		set photopath [FIELD photopath]
		NULL
		append html \"\<table border=0 cellspacing=2 cellpadding=2 width=80%\>\<td\>\"
		if {$photopath != \"\"} {
			append html \"\<img align=right src=$photopath\>\"
		}
		append html \"\<font face=verdana color=gray\>\<font size=4\>\<B\>$name\</B\>\</font\>\<br\>\<font size=2\>\<i\>$title\</i\>\</font\>\</font\>\<p\>$bio\<p\>\"
		append html \"\</td\>\</table\>\"
}

if {$cmd == \"list\"} {
	set oldgroupname old
	set toggle 0
	append html \"\<table border=0 cellpadding=0 cellspacing=0 width=100%\>\"
	SEARCH TABLE $schema.staff INTO staffList SQL \"select id,name,title,groupid from $schema.staff order by groupid,name\"
	FOREACH ROW IN $staffList {
		[
		set name [FIELD name]
		set sid [FIELD id]
		set title [FIELD title]
		set groupid [FIELD groupid]
		if {$groupid != 0} {
			DEFAULT_ROW $schema.staff_groups \"name\" \"id = [FIELD groupid]\"
			SET origgroupname [FIELD name]
			if {$origgroupname != $oldgroupname} {
				append html \"\<tr\>\<td colspan=2\>\<br\>$origgroupname\</td\>\</tr\>\"
				set oldgroupname $origgroupname
				set toggle 0
			}
		}	

		NULL
		if {$toggle == 1} { 
			SET rowcolor #ffffff
			SET toggle 0
		} else { 
			SET rowcolor #eeeeee 
			SET toggle 1
		}
		
		append html \"\<tr bgcolor=$rowcolor\>\<td\>[CURL $_Path one|$sid $name]\</td\>\<td\>$title\</td\>\</tr\>\"
		]
	}
	append html \"\</table\>\"
}

SHOW html
]
	
}

Elapsed Execution Time: 0.031 seconds

Template Variables:

variable	value
ID	one|19
TABLE
gallerypath	/x/tccp/gallery/
domain	tccp.org
clientpath	/x/tccp
app_path	e:/vignette/5.6/docroot
imagepath	/x/tccp/images/
style	/v5/editor/webmc.css
appl_path	/vignette/5.6/docroot
domArray	www tccp org
v5style	<link href='/v5/editor/webmc.css' rel='stylesheet' type='text/css'>
physical	/Vignette/5.6/docroot
homepath	/x
securepath	/x/tccp/secured/
listDir
theParms	one 19
siteid	63
_LastTable	proto_clients
status	L
_Schema_proto_clients	ID SCHEMANAME STATUS VERSIONFLAG HOMEPAGE STYLESHEETPATH STYLESHEETFILENAME LISTSERVEDIR
otherpath	/x/tccp/other/
server	www.tccp.org
schema	tccp
cmd	one
stylesheetpath	/x/tccp/templates/
databasepath	/x/tccp/database/
websitestyle	<link href='' rel='stylesheet' type='text/css'>
templatepath	/x/tccp/templates/
staffid	19
versionflag	35
stylesheetfilename	style.css
homepage
_TEMPLATE_LOOKUP	1
_DefaultRow_proto_clients	proto_clients {63 tccp L 35 {} {} {} {}}
_includedTemplate	PserverLib

DEFAULT_ROW: Unable to find row in table 'tccp.staff' matching condition: 'id = 19'
    while executing
"system_error "$msg""
    (procedure "error" line 55)
    invoked from within
"error "DEFAULT_ROW: Unable to find $errRec in table '$tbl' matching condition: '$whereClause'""
    (procedure "DEFAULT_ROW" line 52)
    invoked from within
"DEFAULT_ROW $schema.staff "*" "id = [SHOW staffid]"
"
    invoked from within
"if {$cmd == "one" || $cmd == ""} {
		DEFAULT_ROW $schema.staff "*" "id = [SHOW staffid]"
		set name [FIELD name]
		set title [FIELD title]
		set e..."
    invoked from within
"SET bodytext {
[
	INCLUDE LIBNAME "PserverLib"
	set theParms [split $ID |]
	set cmd [lindex $theParms 0]
	NULL
	
	if {[SHOW staffid] == ""} {
..."